import numpy as np
import pandas as pd
from dask.array import outer

brand_file_path = '../../data/raw data/餐饮连锁品牌数据.xlsx'
cater_file_path = '../../data/raw data/餐饮连锁数据.xlsx'
sheet_names=['门店信息','菜品信息','营销记录','顾客评价']
sheet_name=sheet_names[1]
df_dish = pd.read_excel(cater_file_path, sheet_name)
# ======================================
# 6️⃣ 导出清洗后的数据
# ======================================
clean_path = '餐饮连锁数据_cleaned.xlsx'
df_dish.to_excel(clean_path, index=False)
print(f"\n✅ 数据清洗完成，已保存至 {clean_path}")